﻿CREATE TABLE [dbo].[ProjektVersion] (
    [ProjektVersionKey] INT           IDENTITY (1, 1) NOT NULL,
    [ProjektVersionTS]  NVARCHAR (18) COLLATE Latin1_General_CI_AS NULL,
    [ProjektKey]        INT           DEFAULT ((0)) NULL,
    [Version]           SMALLINT      DEFAULT ((0)) NULL,
    [Änderung]          DATETIME      NULL,
    [Datum]             DATETIME      NULL,
    [Netto1]            FLOAT (53)    DEFAULT ((0)) NULL,
    [Rabatt_Prozent]    REAL          DEFAULT ((0)) NULL,
    [Rabatt_Wert]       FLOAT (53)    DEFAULT ((0)) NULL,
    [Netto2]            FLOAT (53)    DEFAULT ((0)) NULL,
    [UST]               FLOAT (53)    DEFAULT ((0)) NULL,
    [Brutto]            FLOAT (53)    DEFAULT ((0)) NULL,
    [DB_Wert]           FLOAT (53)    DEFAULT ((0)) NULL,
    [DB_Prozent]        REAL          DEFAULT ((0)) NULL,
    [Summe_Einkauf]     FLOAT (53)    DEFAULT ((0)) NULL,
    CONSTRAINT [PK_ProjektVersion] PRIMARY KEY CLUSTERED ([ProjektVersionKey] ASC)
);

